Expert Oracle Indexing and Access Paths by Darl Kuhn Sam R Alapati & Bill Padfield

Author:Darl Kuhn, Sam R Alapati & Bill Padfield
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA

Summary

This chapter provided an introduction to various specialized indexes that you can create in an Oracle database to enhance performance and make index management simpler. You learned how to use invisible indexes to test the efficiency of indexes. This chapter showed you how to take advantage of function-based indexes to influence the optimizer’s choice of indexes during the execution of queries where the predicates involve a function on a column. This chapter also explained the benefits of key compression and how and when to compress indexes. Composite indexes are very important in many applications and you learned the advantages of using composite indexes. This chapter showed you both how to create and manage indexes on virtual columns, as well as how to create a virtual or fake index that doesn’t utilize any storage. Reverse keys are critical in avoiding contention on hot blocks, especially in an Oracle RAC environment. This chapter explained in detail when and how to create reverse key indexes. It also listed the disadvantages involved in the use of reverse key indexes.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.